| AmProspectPrevEduc |
| Logical Entity Name | AmProspectPrevEduc |
| Default Table Name | AmProspectPrevEduc |
| Physical Only | NO |
| Definition | |
| Note |
| AmProspectPrevEduc Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SyStudentID | int | NO | ||
| AmCollegeID | int | YES | ||
| Status | char(1) | YES | ||
| TranscriptReq | datetime | YES | ||
| FATReq | datetime | YES | ||
| CreditsReq | money | NO | ||
| CreditsOK | money | NO | ||
| ModFlag | char(1) | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | YES | ||
AmProspectPrevEducID |
int | NO | ||
AmPrevEducID |
int | YES | ||
| GPA | numeric(11, 6) | YES | ||
| Graduated | bit | NO | ||
| GraduationSession | varchar(10) | YES | ||
| DateOfEnrollment | datetime | YES | ||
| GraduationDate | datetime | YES | ||
| LastDateAttended | datetime | YES | ||
| StudRank | int | YES | ||
| SchoolSize | int | YES | ||
| TranscriptType | tinyint | YES | ||
| DegreeiD | int | YES | ||
| Major | varchar(100) | YES | ||
| TranscriptID | int | YES | ||
| OtherCollege | varchar(60) | YES | ||
AmGradeLevelID |
int | YES | ||
| HSGradYear | varchar(4) | YES | ||
AmHighSchoolID |
int | YES | ||
| GEDAwardedDate | datetime | YES | ||
| Comments | varchar(2000) | YES | ||
| CrmSuppressFlag | bit | NO | ||
| QualityPoints | numeric(15, 6) | YES | ||
| CreditsAttempt | numeric(9, 2) | YES | ||
| HoursAttempt | numeric(9, 2) | YES | ||
| GradePoints | numeric(9, 2) | YES | ||
| CoursesTaken | int | YES | ||
| ATBCode | char(2) | YES | ||
| ATBAdmin | char(2) | YES | ||
| ATBTest | char(2) | YES | ||
| ATBState | char(2) | YES | ||
| ATBDate | smalldatetime | YES |
| AmProspectPrevEduc Primary and Unique Keys |
| Key Name | Key Type | Keys |
| AmProspectPrevEduc_AmProspectPrevEducID_U_C_IDX | PrimaryKey | AmProspectPrevEducID |
| AmProspectPrevEduc Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| amPrevEduc | Non-Identifying | Zero or One to Zero or More | FK_AmProspectPrevEduc.AmPrevEducID_AmPrevEduc.AmPrevEducID | AmPrevEducID | NO | YES | ||
| AmGradeLevel | Non-Identifying | Zero or One to Zero or More | FK_AmProspectPrevEduc_AmGradeLevelId_AmGradeLevel_AmGradeLevelID | AmGradeLevelID | NO | YES | ||
| AmHighSchool | Non-Identifying | Zero or One to Zero or More | FK_AmProspectPrevEduc_AmHighSchoolId_AmHighSchool_AmHighSchoolID | AmHighSchoolID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| AmProspectPrevEduc Check Constraints |
| Check Constraint Name | CheckConstraint |